<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateOrderAddressTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		//订单发货地址表
		Schema::create('order_address', function(Blueprint $table) {
			$table->increments('id')->comment('地址标识');
			$table->integer('user_id')->comment('用户标识');
			$table->string('consignee',20)->nullable()->comment('收件人');
			$table->string('province',30)->nullabel()->comment('省份');
			$table->string('city',30)->nullable()->comment('城市');
			$table->string('area',30)->nullable()->comment('地区');
			$table->string('add_detail')->nullable()->comment('详细地址');
			$table->string('postcode',10)->nullable()->comment('邮政编码');
			$table->string('mobilephone',20)->nullable()->comment('手机号');
			$table->string('telephone',20)->nullable()->comment('固定电话号码');
			$table->softDeletes();
			$table->timestamps();
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		//
	}

}
